/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80032 (8.0.32)
 Source Host           : localhost:3306
 Source Schema         : renli_manager

 Target Server Type    : MySQL
 Target Server Version : 80032 (8.0.32)
 File Encoding         : 65001

 Date: 27/03/2023 20:56:28
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for staff_wages
-- ----------------------------
DROP TABLE IF EXISTS `staff_wages`;
CREATE TABLE `staff_wages` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `staff_id` bigint NOT NULL COMMENT '员工工号',
  `basic_wage` double DEFAULT '3000' COMMENT '基础工资默认3000',
  `full_attendence_award` double DEFAULT '300' COMMENT '全勤奖',
  `post_pay` double DEFAULT '30' COMMENT '岗位工资,默认一天',
  `overtime_pay` double DEFAULT '15' COMMENT '加班费,默认1小时',
  `late_pay` double DEFAULT '100' COMMENT '缺勤费，默认一天',
  `update_people` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人',
  `update_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `this_months_salary` double DEFAULT NULL COMMENT '本月工资',
  `last_months_salary` double DEFAULT NULL COMMENT '上个月工资',
  `other_pay` double DEFAULT '0' COMMENT '其他奖金',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `overtime_pay_all` double DEFAULT '0' COMMENT '一个月加班费总数',
  `late_pay_all` double DEFAULT '0' COMMENT '缺勤费总数',
  `post_pay_all` double DEFAULT '0' COMMENT '岗位工资总数',
  `date_late` double DEFAULT '20' COMMENT '迟到一次罚款',
  `date_late_all` double DEFAULT '0' COMMENT '本月迟到总罚款',
  PRIMARY KEY (`id`),
  UNIQUE KEY `员工id` (`staff_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1639965997791428610 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of staff_wages
-- ----------------------------
BEGIN;
INSERT INTO `staff_wages` (`id`, `staff_id`, `basic_wage`, `full_attendence_award`, `post_pay`, `overtime_pay`, `late_pay`, `update_people`, `update_time`, `this_months_salary`, `last_months_salary`, `other_pay`, `name`, `overtime_pay_all`, `late_pay_all`, `post_pay_all`, `date_late`, `date_late_all`) VALUES (1, 1639196442747977730, 3000, 300, 30, 15, 100, '待定', '2023-03-27 19:10:15', 3000, NULL, 0, '徐先知', 0, 0, 0, 20, 0);
INSERT INTO `staff_wages` (`id`, `staff_id`, `basic_wage`, `full_attendence_award`, `post_pay`, `overtime_pay`, `late_pay`, `update_people`, `update_time`, `this_months_salary`, `last_months_salary`, `other_pay`, `name`, `overtime_pay_all`, `late_pay_all`, `post_pay_all`, `date_late`, `date_late_all`) VALUES (1639883785914007554, 1639883785855287298, 3000, 300, 30, 15, 100, 'root', '2023-03-27 19:10:14', 4230, NULL, 0, '林大小', 0, 0, 0, 20, 0);
INSERT INTO `staff_wages` (`id`, `staff_id`, `basic_wage`, `full_attendence_award`, `post_pay`, `overtime_pay`, `late_pay`, `update_people`, `update_time`, `this_months_salary`, `last_months_salary`, `other_pay`, `name`, `overtime_pay_all`, `late_pay_all`, `post_pay_all`, `date_late`, `date_late_all`) VALUES (1639893761931812866, 1639893761873092610, 3000, 300, 30, 15, 100, 'root', '2023-03-27 19:10:13', 42330, NULL, 0, '张大炮', 0, 0, 0, 20, 0);
INSERT INTO `staff_wages` (`id`, `staff_id`, `basic_wage`, `full_attendence_award`, `post_pay`, `overtime_pay`, `late_pay`, `update_people`, `update_time`, `this_months_salary`, `last_months_salary`, `other_pay`, `name`, `overtime_pay_all`, `late_pay_all`, `post_pay_all`, `date_late`, `date_late_all`) VALUES (1639893783167574017, 1639893783121436673, 3000, 300, 30, 15, 100, 'root', '2023-03-27 19:10:11', 42320, NULL, 0, '林小鸟', 0, 0, 0, 20, 0);
INSERT INTO `staff_wages` (`id`, `staff_id`, `basic_wage`, `full_attendence_award`, `post_pay`, `overtime_pay`, `late_pay`, `update_people`, `update_time`, `this_months_salary`, `last_months_salary`, `other_pay`, `name`, `overtime_pay_all`, `late_pay_all`, `post_pay_all`, `date_late`, `date_late_all`) VALUES (1639893804059402241, 1639893804017459201, 3000, 300, 30, 15, 100, 'root', '2023-03-27 19:10:10', 42130, NULL, 0, '王三把', 0, 0, 0, 20, 0);
INSERT INTO `staff_wages` (`id`, `staff_id`, `basic_wage`, `full_attendence_award`, `post_pay`, `overtime_pay`, `late_pay`, `update_people`, `update_time`, `this_months_salary`, `last_months_salary`, `other_pay`, `name`, `overtime_pay_all`, `late_pay_all`, `post_pay_all`, `date_late`, `date_late_all`) VALUES (1639893824577937410, 1639893824196255745, 3000, 300, 30, 15, 100, 'root', '2023-03-27 19:10:09', 64230, NULL, 0, '菜鸟送', 0, 0, 0, 20, 0);
INSERT INTO `staff_wages` (`id`, `staff_id`, `basic_wage`, `full_attendence_award`, `post_pay`, `overtime_pay`, `late_pay`, `update_people`, `update_time`, `this_months_salary`, `last_months_salary`, `other_pay`, `name`, `overtime_pay_all`, `late_pay_all`, `post_pay_all`, `date_late`, `date_late_all`) VALUES (1639893842772828162, 1639893842714107906, 3000, 300, 30, 15, 100, 'root', '2023-03-27 19:10:07', 3230, NULL, 0, '张二爷', 0, 0, 0, 20, 0);
INSERT INTO `staff_wages` (`id`, `staff_id`, `basic_wage`, `full_attendence_award`, `post_pay`, `overtime_pay`, `late_pay`, `update_people`, `update_time`, `this_months_salary`, `last_months_salary`, `other_pay`, `name`, `overtime_pay_all`, `late_pay_all`, `post_pay_all`, `date_late`, `date_late_all`) VALUES (1639965997791428609, 1639965997678182402, 7000, 300, 80, 15, 100, 'root', '2023-03-27 19:38:41', 10179, NULL, 0, '测试3', 450, 0, 2480, 20, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
